/*
Copyright (C) 2006  Greg Graham

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

using System;
using System.IO;
using System.Collections.Generic;
using System.Text;

namespace BuildDB
{
    class ScriptFilePlayer
    {

        private string targetServerName;
        private string targetDatabaseName;

        //constructor 
        public ScriptFilePlayer(string targetServerName, string targetDatabaseName)
        {
            this.targetServerName = targetServerName;
            this.targetDatabaseName = targetDatabaseName;
        }

        //call sqlcmd, return pass or fail 
        //Pass the full path name of the file to play 
        public int PlayFile(string fn)
        {

            System.Diagnostics.Process proc = new System.Diagnostics.Process();
            proc.EnableRaisingEvents = false;
            proc.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
            proc.StartInfo.FileName = "sqlcmd";
            proc.StartInfo.Arguments = "-E " +
                " -S " + targetServerName +
                " -d " + targetDatabaseName +
                " -i \"" + fn + "\"" +
                " -b ";
            proc.Start();
            proc.WaitForExit();
            return proc.ExitCode;
        }

    }

}